package com.daxue.se;

/**
 * @author daxue0929
 * @date 2022/9/15
 */

public class Mysql {

    /**
     * 单行函数
     * 1. lower
     * 2. upper
     * 3. substr
     * 4. length
     * 5. trim
     * 5. str_to_date
     * 6. date_format
     * 7. format
     * 8. round
     * 9. rand
     * 10.  case...when...then...when...then...end
     *  select empno,ename,job,sal,case job when 'MANAGER' then sal*1.1 when 'SALESMAN' then sal*1.5 end as netsal from emp;
     * 11. ifnull
     * 分组函数/聚合函数/多行处理函数
     * 1. count()
     * 2. sun
     * 3. avg
     * 4. max
     * 5. min
     * 6. 组合聚合函数
     *
     *
     *
     *
     *
     *
     *
     *
     *
     */

}
